package cn.cloud.butler.uploadapi.repository;

import cn.cloud.butler.uploadapi.domain.*;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface StateTimeSumRepository extends JpaRepository<StateTimeSumEntity,Long> {



    @Query(value="select * from StateTimeSum where UploadTime = ?1 and MacSN = ?2 and RunState = ?3",
            nativeQuery = true)
    StateTimeSumEntity selTodayState(String uploadtime, String macsn, String runstate);


}
